<cfsetting requesttimeout="600" showdebugoutput="no">
<cfscript>
base = new assets.calgrants.com.Base();
currentProgramYear = base.getCurrentProgramYear();
firstProgramYear = "2011-2012";
</cfscript>
 
<cfparam name="Program_Year" type="string" default="#currentProgramYear#" />
<cfparam name="Workshop_ID" type="numeric" default="0" />
<cfparam name="Organization_ID" type="numeric" default="0" />
<cfparam name="Region_ID" type="numeric" default="0" />
<cfparam name="Site_ID" type="numeric" default="0" />
<!--- <cfparam name="Organizer_ID" type="numeric" default="0" />
<cfparam name="Manager_ID" type="numeric" default="0" />
<cfparam name="Zip_Code_ID" type="string" default="0" />
<cfparam name="City_ID" type="string" default="0" />
<cfparam name="County_ID" type="numeric" default="0" />
<cfparam name="School_District_ID" type="numeric" default="0" />
<cfparam name="School_ID" type="numeric" default="0" />
<cfparam name="State_Legislative_District_ID" type="numeric" default="0" /> --->
<cfscript>
	// Gateways
	workshopGateway = new assets.calgrants.com.gateway.WorkshopGateway();
	siteGateway = new assets.calgrants.com.gateway.SiteGateway();
	organizationGateway = new assets.calgrants.com.gateway.OrganizationGateway();
	countyGateway = new assets.calgrants.com.gateway.CountyGateway();
	evaluationGateway = new assets.calgrants.com.gateway.EvaluationGateway();
	gdsGateway = new assets.calgrants.com.gateway.GDSGateway();
	storedProcedureGateway = new assets.calgrants.com.gateway.StoredProcedureGateway();
	// Globals
	colors = ["##2682d6","##5dba5d","##0f2a88","##55b4d0","##417630","##aad9e7","##444444","##ccc","##2682d6","##5dba5d","##0f2a88","##55b4d0","##417630","##aad9e7","##444444","##ccc"];
	evaluationQuestions = "1,6,7,10,11,12";
		
	if (Workshop_ID gt 0) {
		// Variables
		rollupLevel = "workshop";
		// Workshop
		qWorkshop = workshopGateway.query(Workshop_ID = Workshop_ID);
		workshopDate = qWorkshop.Workshop_Date;
		Organization_ID = qWorkshop.Organization_ID;
		organization = qWorkshop.Organization;
		Site_ID = qWorkshop.Site_ID;
		//siteID = qWorkshop.Site_ID;
		site = qWorkshop.Site;
		city = qWorkshop.City;
		siteType = qWorkshop.Site_Type;
		county = qWorkshop.County;
		region = qWorkshop.Region;
		computerBasedWorkshop = qWorkshop.Online;
		followUpRequests = qWorkshop.Follow_Up_Request_Count;
		followUpRequestsPct = qWorkshop.Follow_Up_Request_Count / qWorkshop.Student_Count * 100;
		followedUp = qWorkshop.Complete_Follow_Up_Request_Count;
		Program_Year = qWorkshop.Program_Year;
		//Site
		qSite = siteGateway.query(Site_ID = Site_ID);
		siteSince = qSite.Initial_Program_Year;
		//Organization
		qOrganization = organizationGateway.query(Organization_ID = Organization_ID);
		organizationSince = qOrganization.Initial_Program_Year;
	} else if (Organization_ID gt 0) {
		// Variables
		rollupLevel = "organization";
		// Organization
		qOrganization = organizationGateway.query(Organization_ID = Organization_ID);
		organization = qOrganization.Organization;
		county = qOrganization.County;
		region = qOrganization.Region;
		organizationSince = qOrganization.Initial_Program_Year;
	} else if (Region_ID gt 0) {
		// Variables
		rollupLevel = "region";
		// County
		qCounty = countyGateway.query(Region_ID = Region_ID);
		region = qCounty.Region;
	} else { // Statewide report
		// Variables
		rollupLevel = "statewide";
	}
	evaluations = evaluationGateway.report(programYears = Program_Year, workshopIDs = IIf(Workshop_ID gt 0, DE(Workshop_ID), DE("")), organizationIDs = IIf(Organization_ID gt 0, DE(Organization_ID), DE("")), regionIDs = IIf(Region_ID gt 0, DE(Region_ID), DE("")), excludeOtherResponses = true);
	gds = gdsGateway.query(programYears = Program_Year, workshopIDs = IIf(Workshop_ID gt 0, DE(Workshop_ID), DE("")), organizationIDs = IIf(Organization_ID gt 0, DE(Organization_ID), DE("")), regionIDs = IIf(Region_ID gt 0, DE(Region_ID), DE("")));
	trendWorkshops = workshopGateway.query(Deleted = 0, Approved = 1, siteIDs = IIf(Workshop_ID gt 0, DE(Site_ID), DE("")), organizationIDs = IIf(Organization_ID gt 0, DE(Organization_ID), DE("")), regionIDs = IIf(Region_ID gt 0, DE(Region_ID), DE("")));
	//scholarshipCounts = storedProcedureGateway.getScholarshipCounts(Program_Year = Program_Year, Workshop_ID = IIf(Workshop_ID gt 0, Workshop_ID, ""), Organization_ID = IIf(Organization_ID gt 0, Organization_ID, ""), Region_ID = IIf(Region_ID gt 0, Region_ID, ""));

	totalAttendees = evaluations[1].response_count + evaluations[1].no_response_count;
	seniorAttendees = evaluations[1].senior_response_count + evaluations[1].senior_no_response_count;
	if (totalAttendees gt 0) {
		seniorAttendeesPercent = seniorAttendees/totalAttendees*100;
	} else {
		seniorAttendeesPercent = 0;
	};
	/*******
	gdsMatchCount = gds.RecordCount;
	if (totalAttendees gt 0) {
		gdsMatchPercent = gdsMatchCount/totalAttendees*100;
	} else {
		gdsMatchPercent = 0;
	};
	*******/
	currentData = StructNew();
	genderData = StructNew();
	raceData = StructNew();
	//raceGenderData = StructNew();
	//calGrantData = StructNew();
	gdsData = StructNew();
	trendData = StructNew();
</cfscript>

<!--- need to cache queries, especially trend data --->

<!--- <cfquery name="sgds" dbtype="query" maxrows="10">
select * from gds
</cfquery>
<cfoutput>
	#rollupLevel#<br>
	#Workshop_ID#
</cfoutput>
<cfdump var="#evaluations#" label="evaluations" expand="no">
<cfdump var="#sgds#" label="gds (first 10)" expand="no">
<cfdump var="#trendWorkshops#" label="trendWorkshops" expand="no"> --->


<!--- build currentData from evaluations --->
<cfloop index="q" list="#evaluationQuestions#">
	<cfset currentData[q] = StructCopy(evaluations[q]) />
	<cfloop index="a" from="1" to="#ArrayLen(currentData[q].Answers)#">
		<!--- remove open-ended responses to reduce struct size --->
		<cfset StructDelete(currentData[q].Answers[a], "Answer_Values") />
	</cfloop>
</cfloop>

<!--- build race x gender data
<cfset raceGenderData = StructNew() />
<cfset raceGenderData["aaMales"] = 0 />
<cfset raceGenderData["hispanicMales"] = 0 /> --->

<!--- build trend data --->
<cfquery name="getProgramYears" dbtype="query">
	select	sum(Student_Count) as studentCount,
			count(distinct Workshop_ID) as workshopCount,
			count(distinct Site_ID) as siteCount,
			count(distinct Manager_ID) as managerCount,
			count(distinct Organizer_ID) as organizerCount,
			count(distinct Organization_ID) as organizationCount,
			count(distinct City) as cityCount,
			count(distinct Zip_Code) as zipCodeCount,
			count(distinct County) as countyCount,
			count(distinct Region_ID) as regionCount,
			Program_Year 
	from 	trendWorkshops 
	group by Program_Year 
	having 	Program_Year >= <cfqueryparam cfsqltype="cf_sql_varchar" value="#firstProgramYear#" null="no" />
	and 	Program_Year <= <cfqueryparam cfsqltype="cf_sql_varchar" value="#Program_Year#" null="no" /> 
	and 	studentCount >= <cfqueryparam cfsqltype="cf_sql_integer" value="1" null="no" />
</cfquery>
<cfset programYears = ValueList(getProgramYears.Program_Year) />

<cfdump var="#currentData#">
<cfabort>

--------------------------------------
Add a way to limit the questions that are returned from evaluationGateway.report.
Also beware that the current "evaluationQuestions" variable may use question number which can change year-to-year.  it would be better to use question field instead since it doesn't change
--------------------------------------



<cfloop query="getProgramYears">
	<cfif Workshop_ID gt 0>
		<cfset trend = evaluationGateway.report(programYears = getProgramYears.Program_Year, siteIDs = Site_ID) />
	<cfelseif Organization_ID gt 0>
		<cfset trend = evaluationGateway.report(programYears = getProgramYears.Program_Year, organizationIDs = Organization_ID) />
	<!--- <cfelseif County_ID gt 0>
		<cfset trend = evaluationGateway.report(programYears = getProgramYears.Program_Year, countyIDs = County_ID) /> --->
	<cfelseif Region_ID gt 0>
		<cfset trend = evaluationGateway.report(programYears = getProgramYears.Program_Year, regionIDs = Region_ID) />
	<cfelse>
		<cfset trend = evaluationGateway.report(programYears = getProgramYears.Program_Year) />
	</cfif>
	<cfif NOT StructKeyExists(trendData, "Program_Year_Stats")>
		<cfset trendData["PROGRAM_YEAR_STATS"] = StructNew() />
	</cfif>
	<cfset pyData = StructNew() />
	<cfset pyData["STUDENT_COUNT"] = getProgramYears.studentCount />
	<cfset pyData["SITE_COUNT"] = getProgramYears.siteCount />
	<cfset pyData["MANAGER_COUNT"] = getProgramYears.managerCount />
	<cfset pyData["ORGANIZER_COUNT"] = getProgramYears.organizerCount />
	<cfset pyData["ORGANIZATION_COUNT"] = getProgramYears.organizationCount />
	<cfset pyData["CITY_COUNT"] = getProgramYears.cityCount />
	<cfset pyData["ZIP_CODE_COUNT"] = getProgramYears.zipCodeCount />
	<cfset pyData["COUNTY_COUNT"] = getProgramYears.countyCount />
	<cfset pyData["REGION_COUNT"] = getProgramYears.regionCount />
	<cfset trendData["PROGRAM_YEAR_STATS"][getProgramYears.Program_Year] = pyData />
	<cfloop index="q" list="#evaluationQuestions#">
		<cfif NOT StructKeyExists(trendData, q)>
			<cfset trendData[q] = StructCopy(trend[q])>
			<cfset StructDelete(trendData[q], "Answers") />
			<cfset trendData[q]["ANSWERS"] = StructNew() />
		</cfif>
		<cfloop index="a" from="1" to="#ArrayLen(trend[q].Answers)#">
			<cfif trend[q].Answers[a].Answer_Active eq 1>
				<cfset n = trend[q].Answers[a].Answer_Number />
				<cfif q neq "11" or n neq "3">
					<cfif NOT StructKeyExists(trendData[q]["ANSWERS"], n)>
						<cfset trendData[q]["ANSWERS"][n] = ArrayNew(1) />
					</cfif>
					<cfset dataSet = StructCopy(trend[q].Answers[a]) />
					<cfset StructDelete(dataSet, "ANSWER_VALUES") />
					<cfset dataSet["PROGRAM_YEAR"] = getProgramYears.Program_Year />
					<cfset ArrayAppend(trendData[q]["ANSWERS"][n], dataSet) />
				</cfif>
			</cfif>
		</cfloop>
	</cfloop>
</cfloop>

Done.
<cfabort>







<!--- build gender data --->
<cfset genderAnswers = currentData["11"].Answers />
<cfset genderData["totalCount"] = 0 />
<cfset genderData["maleFemaleCount"] = 0 />
<cfloop index="a" from="1" to="#ArrayLen(genderAnswers)#">
	<cfif genderAnswers[a].Answer neq "Decline to answer">
		<cfset genderData[LCase(genderAnswers[a].Answer) & "Count"] = genderAnswers[a].Response_Count>
		<cfset genderData[LCase(genderAnswers[a].Answer) & "Percent"] = genderAnswers[a].Response_Percent>
	<cfelse>
		<cfset genderData["declineToAnswerCount"] = genderAnswers[a].Response_Count>
		<cfset genderData["declineToAnswerPercent"] = genderAnswers[a].Response_Percent>
	</cfif>
	<cfset genderData["totalCount"] = genderData["totalCount"] + genderAnswers[a].Response_Count />
</cfloop>
<cfset genderData["maleFemaleCount"] = genderData["maleCount"] + genderData["femaleCount"] />
<cfset genderData["femaleOnCount"] = Int(genderData.femalePercent/10) />
<cfset genderData["femaleOffCount"] = 10 - genderData["femaleOnCount"] />
<cfset genderData["femaleCountLeadingCols"] = genderData["femaleOnCount"] - 1 />
<cfset genderData["femaleCountTrailingCols"] = 9 - genderData["femaleCountLeadingCols"] />
<cfset genderData["maleOnCount"] = Int(genderData.malePercent/10) />
<cfset genderData["maleOffCount"] = 10 - genderData["maleOnCount"] />
<cfset genderData["maleCountLeadingCols"] = genderData["maleOnCount"] - 1 />
<cfif genderData["maleCountLeadingCols"] gt 1>
	<cfset genderData["maleCountTrailingCols"] = 8 - genderData["maleCountLeadingCols"] />
<cfelse>
	<cfset genderData["maleCountTrailingCols"] = 8 />
</cfif>

<!--- build race/ethnicity data --->
<cfset raceAnswers = currentData["12"].Answers />
<cfset raceData["totalCount"] = 0 />
<cfloop index="a" from="1" to="#ArrayLen(raceAnswers)#">
	<cfif raceAnswers[a].Answer neq "Decline to answer">
		<cfset raceData[LCase(raceAnswers[a].Answer) & "Count"] = raceAnswers[a].Response_Count>
		<cfset raceData[LCase(raceAnswers[a].Answer) & "Percent"] = raceAnswers[a].Response_Percent>
	<cfelse>
		<cfset raceData["declineToAnswerCount"] = raceAnswers[a].Response_Count>
		<cfset raceData["declineToAnswerPercent"] = raceAnswers[a].Response_Percent>
	</cfif>
	<cfset raceData["totalCount"] = raceData["totalCount"] + raceAnswers[a].Response_Count />
</cfloop>

<!--- build GDS data --->
<cfset gdsData["totalCount"] = 0 />
<cfset gdsData["seniorCount"] = 0 />
<cfset gdsData["fafsaSubmitted"] = 0 />
<cfset gdsData["dreamersSubmitted"] = 0 />
<cfset gdsData["fafsaCompleted"] = 0 />
<cfset gdsData["dreamersCompleted"] = 0 />
<cfset gdsData["fafsaCompletedPercent"] = 0 />
<cfset gdsData["fafsaOnTime"] = 0 />
<cfset gdsData["dreamersOnTime"] = 0 />
<cfset gdsData["fafsaOnTimeCompleted"] = 0 />
<cfset gdsData["dreamersOnTimeCompleted"] = 0 />
<cfset gdsData["fafsaPellEligible"] = 0 />
<cfset gdsData["fafsaDollarsAwarded"] = 0 />
<cfset gdsData["calgrantSubmitted"] = 0 />
<cfset gdsData["calgrantCompleted"] = 0 />
<cfset gdsData["calgrantCompletedPercent"] = 0 />
<cfset gdsData["calgrantAwarded"] = 0 />
<cfset gdsData["calgrantAAwarded"] = 0 />
<cfset gdsData["calgrantBAwarded"] = 0 />
<cfset gdsData["calgrantCAwarded"] = 0 />
<cfset gdsData["calgrantAwardedPercent"] = 0 />
<cfset gdsData["calgrantAAwardedPercent"] = 0 />
<cfset gdsData["calgrantBAwardedPercent"] = 0 />
<cfset gdsData["calgrantCAwardedPercent"] = 0 />
<cfset gdsData["calgrantDollarsAwarded"] = 0 />
<cfset gdsData["calgrantADollarsAwarded"] = 0 />
<cfset gdsData["calgrantBDollarsAwarded"] = 0 />
<cfset gdsData["calgrantCDollarsAwarded"] = 0 />

<cfloop query="gds">
	<cfset gdsData["totalCount"] = gdsData["totalCount"] + 1 />
	<!--- submitted = SSN value --->
	<cfif Len(SSN) gt 0>
		<cfif Left(SSN, 4) eq "0000" or On_Time_Dream_Act_Cal_ISIR eq "Y" or On_Time_Dream_Act_Cal_ISIR eq 1>
			<cfset isDreamer = true />
		<cfelse>
			<cfset isDreamer = false />
		</cfif>
		<cfset gdsData["fafsaSubmitted"] = gdsData["fafsaSubmitted"] + 1 />
		<cfif isDreamer>
			<cfset gdsData["dreamersSubmitted"] = gdsData["dreamersSubmitted"] + 1 />
		</cfif>
		<cfif On_Time_ISIR eq "Y" or On_Time_Dream_Act_Cal_ISIR eq "Y" or On_Time_ISIR eq 1 or On_Time_Dream_Act_Cal_ISIR eq 1>
			<cfset gdsData["fafsaOnTime"] = gdsData["fafsaOnTime"] + 1 />
		</cfif>
		<cfif On_Time_Dream_Act_Cal_ISIR eq "Y" or On_Time_Dream_Act_Cal_ISIR eq 1>
			<cfset gdsData["dreamersOnTime"] = gdsData["dreamersOnTime"] + 1 />
		</cfif>	
		<!--- fafsa/dream act completed --->
		<cfif Len(Trim(Primary_EFC)) gt 0>
			<cfset gdsData["fafsaCompleted"] = gdsData["fafsaCompleted"] + 1 />
			<cfif isDreamer>
				<cfset gdsData["dreamersCompleted"] = gdsData["dreamersCompleted"] + 1 />
			</cfif>
			<cfif On_Time_ISIR eq "Y" or On_Time_Dream_Act_Cal_ISIR eq "Y" or  On_Time_ISIR eq 1 or On_Time_Dream_Act_Cal_ISIR eq 1>
				<cfset gdsData["fafsaOnTimeCompleted"] = gdsData["fafsaOnTimeCompleted"] + 1 />
			</cfif>
			<cfif On_Time_Dream_Act_Cal_ISIR eq "Y" or On_Time_Dream_Act_Cal_ISIR eq 1>
				<cfset gdsData["dreamersOnTimeCompleted"] = gdsData["dreamersOnTimeCompleted"] + 1 />
			</cfif>			
			<cfif Pell_Grant_Elig_Flag eq "Y" or Pell_Grant_Elig_Flag eq 1>
				<cfset gdsData["fafsaPellEligible"] = gdsData["fafsaPellEligible"] + 1 />
				<cfif Program_Year eq "2013-2014">
					<cfset gdsData["fafsaDollarsAwarded"] = gdsData["fafsaDollarsAwarded"] + 3678 />
				<cfelse>
					<cfset gdsData["fafsaDollarsAwarded"] = gdsData["fafsaDollarsAwarded"] + 3685 />
				</cfif>
			</cfif>
		</cfif>
		<!--- calgrant submitted --->
		<cfif Len(GPA) gt 0>
			<cfset gdsData["calgrantSubmitted"] = gdsData["calgrantSubmitted"] + 1 />
			<!--- calgrant completed --->
			<cfif Len(Trim(Primary_EFC)) gt 0 and (On_Time_ISIR eq "Y" or On_Time_Dream_Act_Cal_ISIR eq "Y" or On_Time_ISIR eq 1 or On_Time_Dream_Act_Cal_ISIR eq 1)>
				<cfset gdsData["calgrantCompleted"] = gdsData["calgrantCompleted"] + 1 />
				<cfif Awd_Stat_Code_1 eq "50" or Awd_Stat_Code_1 eq "25" or Awd_Stat_Code_2 eq "50" or Awd_Stat_Code_2 eq "25" or Awd_Stat_Code_3 eq "50" or Awd_Stat_Code_3 eq "25">
					<cfset gdsData["calgrantAwarded"] = gdsData["calgrantAwarded"] + 1 />
					<!--- <cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + 1 /> --->
					<cfif Awd_Stat_Code_1 eq "50">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_1 />
						<cfset gdsData["calgrantADollarsAwarded"] = gdsData["calgrantADollarsAwarded"] + Graw_Amt_1 />
						<cfset gdsData["calgrantAAwarded"] = gdsData["calgrantAAwarded"] + 1 />
					<cfelseif Awd_Stat_Code_2 eq "50">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_2 />
						<cfset gdsData["calgrantBDollarsAwarded"] = gdsData["calgrantBDollarsAwarded"] + Graw_Amt_2 />
						<cfset gdsData["calgrantBAwarded"] = gdsData["calgrantBAwarded"] + 1 />
					<cfelseif Awd_Stat_Code_3 eq "50">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_3 />
						<cfset gdsData["calgrantCDollarsAwarded"] = gdsData["calgrantCDollarsAwarded"] + Graw_Amt_3 />
						<cfset gdsData["calgrantCAwarded"] = gdsData["calgrantCAwarded"] + 1 />
					<cfelseif Awd_Stat_Code_1 eq "25">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_1 />
						<cfset gdsData["calgrantADollarsAwarded"] = gdsData["calgrantADollarsAwarded"] + Graw_Amt_1 />
						<cfset gdsData["calgrantAAwarded"] = gdsData["calgrantAAwarded"] + 1 />
					<cfelseif Awd_Stat_Code_2 eq "25">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_2 />
						<cfset gdsData["calgrantBDollarsAwarded"] = gdsData["calgrantBDollarsAwarded"] + Graw_Amt_2 />
						<cfset gdsData["calgrantBAwarded"] = gdsData["calgrantBAwarded"] + 1 />
					<cfelseif Awd_Stat_Code_3 eq "25">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_3 />
						<cfset gdsData["calgrantCDollarsAwarded"] = gdsData["calgrantCDollarsAwarded"] + Graw_Amt_3 />
						<cfset gdsData["calgrantCAwarded"] = gdsData["calgrantCAwarded"] + 1 />
					</cfif>
				</cfif>
			</cfif>
		</cfif>
	</cfif>
</cfloop>
<cfif gdsData["fafsaSubmitted"] gt 0>
	<cfset gdsData["fafsaSubmittedPercent"] = Int(gdsData["fafsaSubmitted"]/totalAttendees*100) />
	<cfset gdsData["fafsaCompletedPercent"] = Int(gdsData["fafsaCompleted"]/gdsData["fafsaSubmitted"]*100) />
	<cfset gdsData["fafsaCompletedGingerbreadCount"] = Int(gdsData["fafsaCompleted"]/gdsData["fafsaSubmitted"]*10) />
<cfelse>
	<cfset gdsData["fafsaSubmittedPercent"] = 0 />
	<cfset gdsData["fafsaCompletedPercent"] = 0 />
	<cfset gdsData["fafsaCompletedGingerbreadCount"] = 0 />
</cfif>
<cfset gdsData["fafsaSubmittedGingerbreadCount"] = 10 - gdsData["fafsaCompletedGingerbreadCount"] />
<cfset gdsData["fafsaCountLeadingCols"] = (Int(gdsData["fafsaCompletedPercent"]/10)) - 1 />
<cfset gdsData["fafsaCountTrailingCols"] = 9 - gdsData["fafsaCountLeadingCols"] />
<cfif gdsData["calgrantSubmitted"] gt 0>
	<cfset gdsData["calgrantSubmittedPercent"] = Int(gdsData["calgrantSubmitted"]/totalAttendees*100) />
	<cfset gdsData["calgrantCompletedPercent"] = Int(gdsData["calgrantCompleted"]/gdsData["calgrantSubmitted"]*100) />
	<cfset gdsData["calgrantAwardedPercent"] = Int(gdsData["calgrantAwarded"]/gdsData["calgrantSubmitted"]*100) />
	<cfset gdsData["calgrantAwardedGingerbreadCount"] = Int(gdsData["calgrantAwarded"]/gdsData["calgrantSubmitted"]*10) />
	<cfset gdsData["calgrantCompletedGingerbreadCount"] = Int(gdsData["calgrantCompleted"]/gdsData["calgrantSubmitted"]*10) - gdsData["calgrantAwardedGingerbreadCount"] />
<cfelse>
	<cfset gdsData["calgrantSubmittedPercent"] = 0 />
	<cfset gdsData["calgrantCompletedPercent"] = 0 />
	<cfset gdsData["calgrantAwardedPercent"] = 0 />
	<cfset gdsData["calgrantAwardedGingerbreadCount"] = 0 />
	<cfset gdsData["calgrantCompletedGingerbreadCount"] = 0 />
</cfif>
<cfset gdsData["calgrantSubmittedGingerbreadCount"] = 10 - (gdsData["calgrantAwardedGingerbreadCount"] + gdsData["calgrantCompletedGingerbreadCount"]) />
<cfset gdsData["calgrantCountLeadingColsTop"] = (Int(gdsData["calgrantCompletedPercent"]/10)) - 1 />
<cfset gdsData["calgrantCountTrailingColsTop"] = 9 - gdsData["calgrantCountLeadingColsTop"] />
<cfset gdsData["calgrantCountLeadingColsBottom"] = (Int(gdsData["calgrantAwardedPercent"]/10)) - 1 />
<cfif gdsData["calgrantCountLeadingColsBottom"] gte 1>
	<cfset gdsData["calgrantCountTrailingColsBottom"] = 9 - gdsData["calgrantCountLeadingColsBottom"] - 1 />
<cfelse>
	<cfset gdsData["calgrantCountTrailingColsBottom"] = 8 />
</cfif>

<cfset exportData = StructNew() />
<cfset exportData.Program_Year = Program_Year />
<cfset exportData.Total_Attendees = Int(totalAttendees) />
<!--- <cfset exportData.Exact_Dupes = Int(9999999) /> --->
<cfset exportData.Total_Seniors = Int(seniorAttendees) />
<cfset exportData.Percent_Seniors = DecimalFormat(seniorAttendeesPercent) />
<cfset exportData.Total_Non_Seniors = Int(totalAttendees - seniorAttendees) />
<cfset exportData.Percent_Non_Seniors = 100 - seniorAttendeesPercent />
<!--- <cfset exportData.Workshops_With_Survey = DecimalFormat(9999999) />
<cfset exportData.Web_Based_Workshops = DecimalFormat(9999999) /> --->
<cfset exportData.GDS_Matches = Int(gdsData["totalCount"]) />
<cfset exportData.Submitted_FAFSA_Dream_Act = Int(gdsData["fafsaSubmitted"]) />
<cfset exportData.Submitted_FAFSA = gdsData["fafsaSubmitted"] - gdsData["dreamersSubmitted"] />
<cfset exportData.Submitted_Dream_Act = Int(gdsData["dreamersSubmitted"]) />
<cfset exportData.Completed_FAFSA_Dream_Act = Int(gdsData["fafsaCompleted"]) />
<cfset exportData.Completed_FAFSA = gdsData["fafsaCompleted"] - gdsData["dreamersCompleted"] />
<cfset exportData.Completed_Dream_Act = Int(gdsData["dreamersCompleted"]) />
<cfset exportData.On_Time_FAFSA_Dream_Act = Int(gdsData["fafsaOnTime"]) />
<cfset exportData.On_Time_FAFSA = gdsData["fafsaOnTime"] - gdsData["dreamersOnTime"] />
<cfset exportData.On_Time_Dream_Act = Int(gdsData["dreamersOnTime"]) />
<cfset exportData.On_Time_Completed_FAFSA_Dream_Act = Int(gdsData["fafsaOnTimeCompleted"]) />
<cfset exportData.On_Time_Completed_FAFSA = gdsData["fafsaOnTimeCompleted"] - gdsData["dreamersOnTimeCompleted"] />
<cfset exportData.On_Time_Completed_Dream_Act = Int(gdsData["dreamersOnTimeCompleted"]) />
<!--- <cfset exportData.Dream_Act_No_App = Int(99999999) />
<cfset exportData.AA_Males = Int(99999999) />
<cfset exportData.Hispanic_Males = Int(99999999) /> --->
<cfset exportData.Cal_Grant_A_Count = Int(gdsData["calgrantAAwarded"]) />
<cfset exportData.Cal_Grant_B_Count = Int(gdsData["calgrantBAwarded"]) />
<cfset exportData.Cal_Grant_C_Count = Int(gdsData["calgrantCAwarded"]) />
<cfset exportData.Cal_Grant_A_Amount = Int(gdsData["calgrantADollarsAwarded"]) />
<cfset exportData.Cal_Grant_B_Amount = Int(gdsData["calgrantBDollarsAwarded"]) />
<cfset exportData.Cal_Grant_C_Amount = Int(gdsData["calgrantCDollarsAwarded"]) />
<cfset exportData.Pell_Eligible = Int(gdsData["fafsaPellEligible"]) />
<!--- <cfset exportData.No_GPA = Int(99999999) />
<cfset exportData.GPA_LT_2 = Int(99999999) />
<cfset exportData.WebGrants_Account = Int(99999999) /> --->

<!--- <cfdump var="#exportData#">
<cfdump var="#raceData#" expand="no" label="raceData" />
<cfdump var="#genderData#" expand="no" label="genderData" />
<cfdump var="#gdsData#" expand="no" label="gdsData" /> --->
<!--- <cfdump var="#evaluations#" expand="no" label="evaluations" />
<cfabort> --->

<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>Cash for College How Did We Do Report</title>
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta name="description" content="Cash for College How Did We Do Report">
	<meta name="author" content="Syntric">
	<!--- <link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.common.min.css" rel="stylesheet" type="text/css" />
	<link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.rtl.min.css" rel="stylesheet" type="text/css" />
	<link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.default.min.css" rel="stylesheet" type="text/css" />
	<link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.dataviz.min.css" rel="stylesheet" type="text/css" />
	<link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.dataviz.default.min.css" rel="stylesheet" type="text/css" />
	<link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.mobile.all.min.css" rel="stylesheet" type="text/css" /> --->
	<link href="/assets/kendoui/styles/kendo.common.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/kendoui/styles/kendo.rtl.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/kendoui/styles/kendo.default.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/kendoui/styles/kendo.dataviz.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/kendoui/styles/kendo.dataviz.default.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/kendoui/styles/kendo.mobile.all.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/fonts/cabin/cabin.css" rel="stylesheet" type="text/css" />
	<link href="/assets/fonts/cabin-condensed/cabin-condensed.css" rel="stylesheet" type="text/css" />
	<link href="/assets/fonts/open-sans/open-sans.css" rel="stylesheet" type="text/css" />
	<link href="/assets/fonts/open-sans-condensed/open-sans-condensed.css" rel="stylesheet" type="text/css" />
	<link href="/assets/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/font-awesome/css/font-awesome-ie7.min.css" rel="stylesheet" type="text/css" />
	<script src="/assets/jquery/jquery.min.js" type="text/javascript"></script>
	<script src="/assets/kendoui/js/kendo.all.min.js"></script>
	<!--- <script src="http://cdn.kendostatic.com/2014.3.1119/js/kendo.all.min.js"></script> --->
	<style type="text/css">
		/*.printPage {width: 1125px; max-height: 1455px; height: 1455px; border: solid 0 #000; page-break-inside: avoid !important;}*/
		@media all {.printPage {display: inherit;}}
		@media print {.printPage {display: block; page-break-before: always;}}
		
		.default {color: #aad9e7;}
		.aqua {color: #55b4d0;}
		.blue {color: #2682d6;}
		.blueDark {color: #0f2a88;}
		.green {color: #5dba5d;}
		.greenDark {color: #417630;}
		.greyDark {color: #444444;}
		.greyLight {color: #aaa89a;}
		.white {color: #fff;}
		.goldDark {color: #C90;}
		
		
		body {font-family: "Open Sans", courier; background-color: #fff; margin: 0; padding: 0; text-rendering: optimizelegibility;}
		<!--- /*.main {width: 1125px; max-height: 1455px; height: 1455px; page-break-inside: avoid !important;}
		.main {border: solid 1px blue;}*/
		.main {width: 1125px; max-height: 1455px; height: 1455px;} --->
		.main {width: 1125px; max-height: 1460px; height: 1460px;}
		.navCol {width: 160px; min-width: 160px; max-width: 160px; background-image: url('/assets/calgrants/ui/images/hdwd/nav-col-bg.png'); background-repeat: repeat-y; background-size: contain;}
		.bodyCol {background-color: #fff;}
		<!--- /*.nav {margin-top: 12px;}*/ --->
		.navHeader {height: 247px; background-image: url('/assets/calgrants/ui/images/hdwd/nav-col-header-shadow-background.png'); background-repeat: no-repeat; background-size: contain;}
		.navBody {padding: 10px 6px 6px 6px;}
		<!--- .body {margin: 0 0 0 6px;} --->
		.mission {font-size: 0.8em; color: #fff; line-height: 1.2em;}
		<!--- /* column width classes */
		.{min-width: 21px; width: 21px; max-width: 21px;} /* center col spacer */
		. {min-width: 90px; width: 90px; max-width: 90px;} /* teardrop, tearpanel */
		.{min-width: 152px; width: 152px; max-width: 152px;} /* legend */
		.col160w {min-width: 160px; width: 160px; max-width: 160px;} /* nav */
		.col186w {min-width: 186px; width: 186px; max-width: 186px;} /* dollar award */
		.col210w {min-width: 210px; width: 210px; max-width: 210px;} /* dollar award */
		.col242w {min-width: 242px; width: 242px; max-width: 242px;} /* arrow */
		.col266w {min-width: 266px; width: 266px; max-width: 266px;} /* arrow */
		.{min-width: 300px; width: 300px; max-width: 300px;} /* donut chart */
		. {min-width: 362px; width: 362px; max-width: 362px;} /* gingerbread chart */
		.{min-width: 452px; width: 452px; max-width: 452px;} /* stat header, half body col */
		/* column height classes */
		.{min-height: 40px; max-height: 40px; height: 40px;}
		.col60h {min-height: 60px; max-height: 60px; height: 60px;}
		. {min-height: 80px; max-height: 80px; height: 80px;}
		.col115h {min-height: 115px; max-height: 115px; height: 115px;}
		. {min-height: 215px; max-height: 215px; height: 215px;}
		. {min-height: 274px; max-height: 274px; height: 274px;}
		. {min-height: 300px; max-height: 300px; height: 300px;} --->

		<!--- .logo {width: 131px;} --->
		.logoText {max-height: 128px;}
		<!--- /*.howDid {font-family: "Cabin Condensed"; font-size: 2.1em; text-align: center; line-height: 1em;}
		.weDo {font-family: "Cabin Condensed"; font-size: 2.9em; text-align: center; line-height: 1em;}*/ --->
		.logoYearText {font-family: "Cabin Condensed"; font-size: 2.8em; color: gold; text-align: center; display: block; margin: 0; padding: 0;}
		.sideLabel {font-family: "Open Sans Bold"; font-size: 0.8em; margin-bottom: 0; color: #444444;}
		.sideText {font-family: "Open Sans Condensed Light"; font-size: 1.3em; margin-bottom: 10px; line-height: 1em; color: #fff;}
		.statHeader {font-family: "Cabin Condensed Semibold"; font-size: 1.6em;}
		
		.gingerbreadTable {width: 100%;}
		.gingerbread {width: 34px; height: 75px;}
		.teardrop {width: 50px; height: 50px;}
		h3.blue, h3.blueDark {margin: 0px; -webkit-margin-before: 0px; -webkit-margin-after: 0px; -webkit-margin-start: 0px; -webkit-margin-end: 0px; padding: 0px;}
		hr {border: 0; border-bottom: 3px solid #ccc; background: #fff;}

		.gingerbreadTopRow td, .gingerbreadBottomRow td  {font-family: "Open Sans Bold"; width: 34px; max-width: 34px; min-width: 34px; font-size: 0.7em; line-height: 0.7em; text-align: center;}
		<cfif totalAttendees gte 10000>
			.gingerbreadTopRow td, .gingerbreadBottomRow td  {font-size: 0.6em;}
		</cfif>
		.gingerbreadUpperRow td, .gingerbreadLowerRow td {width: 34px; max-width: 34px; min-width: 34px; height: 75px;}
		
		/* gingerbread backgrounds */
		.femaleGreen {background-image: url('/assets/calgrants/ui/images/hdwd/female-green.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
		.femaleBlue {background-image: url('/assets/calgrants/ui/images/hdwd/female-blue.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
		.femaleDefault {background-image: url('/assets/calgrants/ui/images/hdwd/female-default.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
		.maleGreen {background-image: url('/assets/calgrants/ui/images/hdwd/male-green.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
		.maleBlue {background-image: url('/assets/calgrants/ui/images/hdwd/male-blue.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
		.maleDefault {background-image: url('/assets/calgrants/ui/images/hdwd/male-default.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
	
		/* review this */
		<cfif gdsData["totalCount"] lt 10000>
			.teardropSmall td {width: 70px; height: 70px; color: #fff; font-size: 0.6em; font-weight: 700; line-height: 1.2em; background-repeat: no-repeat; background-position: center; background-size: contain;}
			.upsize150 {font-size: 1.5em; font-weight: 700;}
		<cfelse>
			.teardropSmall td {width: 70px; height: 70px; color: #fff; font-size: 0.6em; font-weight: 700; line-height: 1.2em; background-repeat: no-repeat; background-position: center; background-size: contain;}
			.upsize150 {font-size: 1.4em; font-weight: 700;}
		</cfif>
		.teardropHalfSmall td {height: 35px;}
		.defaultTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/default-teardrop-ne-small.png');}
		.aquaTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/aqua-teardrop-ne-small.png');}
		.blueTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/blue-teardrop-ne-small.png');}
		.blueDarkTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/blue-dark-teardrop-ne-small.png');}
		.greenTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/green-teardrop-ne-small.png');}
		.greenDarkTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/green-dark-teardrop-ne-small.png');}
		.greyDarkTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/grey-dark-teardrop-ne-small.png');}
		.defaultTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/default-teardrop-nw-small.png');}
		.aquaTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/aqua-teardrop-nw-small.png');}
		.blueTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/blue-teardrop-nw-small.png');}
		.blueDarkTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/blue-dark-teardrop-nw-small.png');}
		.greenTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/green-teardrop-nw-small.png');}
		.greenDarkTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/green-dark-teardrop-nw-small.png');}
		.greyDarkTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/grey-dark-teardrop-nw-small.png');}
	
		/* check this font-weight */
		.tearpanel td {width: 35px; height: 130px; font-family: "Open Sans Semibold"; color: #fff; font-size: 0.8em; line-height: 1em; background-repeat: no-repeat; background-size: contain;}
		.femaleTearpanel {background-image: url('/assets/calgrants/ui/images/hdwd/female-tearpanel.png'); background-position: top;}
		.maleTearpanel {background-image: url('/assets/calgrants/ui/images/hdwd/male-tearpanel.png'); background-position: bottom;}
	
		.ratingPercentRow td {font-family: "Open Sans Condensed Bold"; font-size: 4em; text-align: center; line-height: 1em; padding: 6px;}
		.ratingPercentLabelRow td {font-family: "Cabin Semibold"; font-size: 1.4em; text-align: center; line-height: 1em; padding: 6px;}
		span.ratingPercentSymbol {font-size: 0.8em;}
		
		.legendTable td {font-size: 0.8em; padding: 4px 2px; line-height: 1em; font-weight: 500; color: #444444;}
		
		#genderPercentages td {color: #fff; font-size: 0.8em; font-weight: bold; text-align: center; vertical-align: middle;}
		.trendChartLabel {font-size: 1em; line-height: 1.2em; padding-bottom: 2px; color: #444444; height: 40px; text-align: left; vertical-align: middle;}
		/*.arrow {font-family: "Open Sans Semibold"; background-repeat: no-repeat; background-position: left; background-size: contain; font-size: 0.8em; color: #fff; padding-left: 6px; line-height: 1.2em;}
		.blueArrowRight {background-image: url('/assets/calgrants/ui/images/hdwd/blue-arrow-right.png');}
		.greenArrowRight {background-image: url('/assets/calgrants/ui/images/hdwd/green-arrow-right.png');}*/
		<cfif gdsData["calgrantDollarsAwarded"] lt 1000000>
			.dollarAward {font-family: "Open Sans Condensed Bold"; font-size: 2.6em; color: #5dba5d; text-align: right; padding-right: 4px;}
		<cfelse>
			.dollarAward {font-family: "Open Sans Condensed Bold"; font-size: 2.2em; color: #5dba5d; text-align: right; padding-right: 4px;}
		</cfif>
		.sourceInfo {margin: 10px; width: 1125px;}
		.sourceInfo p {font-size: 0.9em; line-height: 1.3em; padding: 12px;}
		.svgChart {display: none;}
	</style>
	<script type="application/javascript">
	<!--
		<cfoutput>
			var programYears = [#QuotedValueList(getProgramYears.Program_Year)#];
			var currentData = #SerializeJSON(currentData)#;
			var trendData = #SerializeJSON(trendData)#;
			var rollupLevel = "#rollupLevel#";
			<!--- var oId = #oID#; --->
			var colors = #SerializeJSON(colors)#;
		</cfoutput>
		
		var donutLabelTemplate = "#= dataItem.percent#%";
		var donutLegendTemplate = "#= dataItem.name#";
		var pieLabelTemplate = "#= dataItem.name# - #= dataItem.percent#%";
		var pieLegendTemplate = "#= dataItem.name# - #= dataItem.percent#%";
		var pieTooltipTemplate = "#= dataItem.name# - #= dataItem.percent#";
		var donutTooltipTemplate = "#= dataItem.count# responses = #= dataItem.percent#%";
		var barLabelTemplate = "#= dataItem.name# - #= dataItem.percent#%";
		var barLegendTemplate = "#= text#";
		var barTooltipTemplate = "#= dataItem.count# responses = #= dataItem.percent#%";
		var donutLabelFont = "9px Arial,Helvetical,sans-serif";
		var labelFont = "9px Arial,Helvetical,sans-serif";
		var legendFont = "9px Arial,Helvetical,sans-serif";
		var tooltipFont = "9px Arial,Helvetical,sans-serif";

		getCurrentQuestionData = function(q) {
			var d = currentData[q]["ANSWERS"];
			var r = [];
			for (var k in d) {
				var s = {};
				if (q == 7) {
					if (d[k]["ANSWER"] == true) {
						s["name"] = "Senior";
					} else if (d[k]["ANSWER"] == false) {
						s["name"] = "Non-senior";
					} else {
						s["name"] = "Family member of senior";
					}
				} else {
					if (d[k]["ANSWER"] == true) {
						s["name"] = "Yes";
					} else if (d[k]["ANSWER"] == false) {
						s["name"] = "No";
					} else {
						s["name"] = d[k]["ANSWER"];
					}
				}
				s["count"] = parseInt(d[k]["RESPONSE_COUNT"]);
				s["percent"] = parseInt(d[k]["RESPONSE_PERCENT"]);
				r.push(s);
			}
			return r;
		}
		getTrendQuestionData = function(q) {
			var d = trendData[q]["ANSWERS"];
			var r = [];
			for (var k in d) {
				var s = {};
				s["counts"] = [];
				s["percents"] = [];
				s["data"] = [];
				for (var j=0; j<d[k].length; j++) {
					s["name"] = d[k][j]["ANSWER"];
					s["counts"].push(parseInt(d[k][j]["RESPONSE_COUNT"]));
					s["percents"].push(parseInt(d[k][j]["RESPONSE_PERCENT"]));
					s["data"].push(parseInt(d[k][j]["RESPONSE_PERCENT"]));
				}
				r.push(s);
			}
			return r;
		}
		renderDonutChart = function(q) {
			$("#q" + q + "DonutChart").kendoChart({
				renderAs: "svg",
				series: [{
					type: "donut",
					data: getCurrentQuestionData(q),
					field: "percent",
					categoryField: "name",
					overlay: "",
					startAngle: 90,
					labels: {
						align: "circle",
						color: "#444444",
						distance: 16,
						position: "outsideEnd",
						template: donutLabelTemplate,
						visible: true,
						border: {width: 0, color: "#FFFFFF"}
					},
					border: {width: 2, color: "#fff"},
					visibleInLegend: false
				}],
				chartArea: {
					width: 278,
					height: 278,
					margin: 0
				},
				seriesColors: colors,
				legend: {
					visible: false,
					position: "bottom",
					labels: {
						font: donutLabelFont,
						template: donutLegendTemplate
					}
				},
				tooltip: {
					visible: false,
					//font: tooltipFont,
					template: donutTooltipTemplate
				}
			})
		}
		renderTrendLineChart = function(q) {
			$("#q" + q + "TrendLineChart").kendoChart({
				renderAs: "svg",
				legend: {visible: false},
				seriesDefaults: {
					type: "line",
					opacity: 1
				},
				series: getTrendQuestionData(q),
				seriesColors: colors,
				chartArea: {
					width: 468,
					height: 278
				},
				valueAxis: {
					min: 0,
					max: 100,
					labels: {format: "{0}%", color: "#444444"},
					line: {visible: false}, 
					majorUnit: 25,
					minorUnit: 12.5,
					majorGridLines: {visible: true, width: 1, dashType: "dot"},
					minorGridLines: {visible: true, width: 1, dashType: "dot"}
				},
				categoryAxis: {
					categories: programYears,
					labels: {
						template: function(d) {
							return d.value.split("-")[1];
						},
						color: "#444444",
						rotation: -45
					},
					line: {visible: false},
					majorGridLines: {visible: false},
					minorGridLines: {visible: false}	
				}
			});
			<!--- if (q === 10) {
				window.setTimeout(function() {
					var thisChart = $("#q10TrendLineChart").getKendoChart();
					thisChart.exportImage().done(function(data) {
						kendo.saveAs({
							dataURI: data,
							filename: "q10TrendLineChart.png"
						})
					})
				}, 2000);
			} --->
		}
		renderTrendAreaChart = function(q) {
			$("#q" + q + "TrendAreaChart").kendoChart({
				renderAs: "svg",
				legend: {visible: false},
				seriesDefaults: {
					type: "area",
					opacity: 1
				},
				series: getTrendQuestionData(q),
				seriesColors: colors,
				chartArea: {
					width: 468,
					height: 278
				},
				valueAxis: {
					min: 0,
					max: 100,
					labels: {format: "{0}%", color: "#444444"},
					line: {visible: false}, 
					majorUnit: 25,
					minorUnit: 12.5,
					majorGridLines: {visible: true, width: 1, dashType: "dot"},
					minorGridLines: {visible: true, width: 1, dashType: "dot"}
				},
				categoryAxis: {
					categories: programYears,
					labels: {
						template: function(d) {
							return d.value.split("-")[1];
						},
						color: "#444444",
						rotation: -45
					},
					line: {visible: false},
					majorGridLines: {visible: false},
					minorGridLines: {visible: false}	
				}
			})
		}
		getChartImage = function(q) {
			var chart = $("#q" + q + "DonutChart").data("kendoChart");
			//console.log(chart);
			var png = chart.imageDataURL();
			/*console.log(png);
			if (!window.open(png)) {
				document.location.href = png;
			}*/
		}
		generatePNGs = function() {
			var svgCharts = $(".svgDonutChart");
			if (programYears.length > 1) {
				svgCharts.concat($(".svgTrendLineChart"), $(".svgTrendAreaChart"));
			}
			var pngCharts = [];
			var dest = 'C\:\\inetpub\\assets\\calgrants\\temp\\';
			for (var i=0; i<svgCharts.length; i++) {
				//console.log($("#" + svgCharts[i].id).data("kendoChart").imageDataURL());
				var chartId = svgCharts[i].id;
				var svgChart = $("#" + chartId).data("kendoChart");
				var pngBase64 = svgChart.imageDataURL();
				//console.log(pngBase64);
				var chartFileName = chartId + "_" + rollupLevel + "_" + oId;
				//console.log("--------- Generating PNG " + chartId + " ---------");
				$.ajax({
					type: "post",
					url: "/assets/calgrants/com/API.cfc?method=generatePNG",
					data: {"pngBase64String": pngBase64, "destination": dest + chartFileName + ".png"},
					async: true,
					cache: false,
					dataType: "json",
					success: function(response, textStatus, jqXHR){
						//console.log("--------- Successfully generated PNG " + chartFileName + " ---------");
						var pathStrArray = response.DATA.split("\\");
						var fileNameStrArray = pathStrArray[pathStrArray.length - 1].split("_");
						var divId = fileNameStrArray[0] + "PNG";
						//console.log(pathStrArray[pathStrArray.length - 1]);
						$("#" + divId + " img").attr("src", "\/assets\/calgrants\/temp\/" + pathStrArray[pathStrArray.length - 1]);
					},
					error: function(jqXHR, textStatus, errorThrown){
						//console.log("--------- Error generating PNG " + chartFileName + " ---------");
						//console.log(errorThrown);
					}
				});
			}
		}
		$(function() {
			renderDonutChart(6);
			renderDonutChart(7);
			renderDonutChart(10);
			renderDonutChart(12);
			if (programYears.length > 1) {
				renderTrendLineChart(1);
				renderTrendLineChart(11);
				renderTrendAreaChart(7);
				renderTrendLineChart(12);
				renderTrendLineChart(6);
				renderTrendLineChart(10);
			}
			window.setTimeout(function() {
				
			}, 7000);
		})
	//-->
	</script>
</head>

<body>
<cfoutput>
	<cfif ListLen(programYears) lte 1>
		<!--- non-trend --->
		<div class="printPage">
			<table class="main" border="0" cellpadding="0" cellspacing="0">
				<tr valign="top">
					<td class="navCol" style="padding-top: 12px;">
						<table class="nav" border="0" cellpadding="0" cellspacing="0">
							<tr valign="top">
								<td class="navHeader" align="center">
									<table border="0" cellpadding="0" cellspacing="0" style="border-spacing: 0px;">
										<tr>
											<td class="logo" align="center"><img src="/assets/calgrants/ui/images/hdwd/cash-for-college-logo_hires.png" /></td>
										<tr>
											<td class="logoText" align="center">
												<img src="/assets/calgrants/ui/images/hdwd/how-did-we-do-cropped.png" />
												<div class="logoYearText">IN&nbsp;#ListLast(Program_Year, "-")#</div>
											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr valign="top">
								<td class="navBody">
									<cfif IsDefined("site")>
										<div class="sideLabel">Site Name</div>
										<div class="sideText">#site#</div>
									</cfif>
									<cfif IsDefined("siteType")>
										<div class="sideLabel">Site Type</div>
										<div class="sideText">#siteType#</div>
									</cfif>
									<cfif IsDefined("siteSince")>
										<div class="sideLabel">Site Since</div>
										<div class="sideText">#siteSince#</div>
									</cfif>
									<cfif IsDefined("city")>
										<div class="sideLabel">City</div>
										<div class="sideText">#city#</div>
									</cfif>
									<cfif IsDefined("county")>
										<div class="sideLabel">County</div>
										<div class="sideText">#county#</div>
									</cfif>
									<cfif IsDefined("region")>
										<div class="sideLabel">Region</div>
										<div class="sideText">#region#</div>
									</cfif>
									<cfif IsDefined("workshopDate")>
										<div class="sideLabel">Workshop Date</div>
										<div class="sideText">#DateFormat(workshopDate, "mmmm d, yyyy")#</div>
									</cfif>
									<cfif IsDefined("computerBasedWorkshop")>
										<div class="sideLabel">Computer Based Workshop</div>
										<div class="sideText">#YesNoFormat(computerBasedWorkshop)#</div>
									</cfif>
									<cfif IsDefined("organization")>
											<div class="sideLabel"><cfif Workshop_ID gt 0>Lead </cfif>Organization</div>
											<div class="sideText">#organization#</div>
									</cfif>
									<cfif IsDefined("organizationSince")>
										<div class="sideLabel">Organization Since</div>
										<div class="sideText">#organizationSince#</div>
									</cfif>
									<div class="sideLabel">Total Attendees</div>
									<div class="sideText">#NumberFormat(totalAttendees)#</div>
									<div class="sideLabel">Senior Attendees</div>
									<div class="sideText">#NumberFormat(seniorAttendees)# (#Int(seniorAttendeesPercent)#%)</div>
									<cfif IsDefined("followUpRequests") and IsDefined("followUpRequestsPct")>
										<div class="sideLabel">Follow-Up Requests</div>
										<div class="sideText">#followUpRequests# (#Int(followUpRequestsPct)#%)</div>
									</cfif>
									<cfif IsDefined("followedUp")>
										<div class="sideLabel">Used Follow-Up Platform?</div>
										<div class="sideText"><cfif followedUp gt 0>Yes (#followedUp#)<cfelse>No</cfif></div>
									</cfif>
									<!--- <cfif scholarshipCounts.RecordCount gt 0>
										<cfif Workshop_ID gt 0>
											<div class="sideLabel">Cash for College Scholarship Awarded?</div>
											<div class="sideText">Yes</div>
										<cfelse>
											<div class="sideLabel">Scholarships Awarded</div>
											<div class="sideText">Yes</div>
										</cfif>
									</cfif> --->
								</td>
							</tr>
						</table>
					</td>
					<td class="bodyCol" style="padding-top: 12px; padding-right: 10px; padding-left: 10px;">
						<table class="body" border="0" cellpadding="0" cellspacing="0" width="100%">
							<tr>
								<td class="statHeader">FAFSA/DREAM ACT APPLICATIONS</td>
								<td>&nbsp;</td>
								<td class="statHeader">CAL GRANT APPLICATIONS</td>
							</tr>
							<tr valign="top">
								<td>
									<table border="0" cellpadding="0" cellspacing="0" class="gingerbreadTable">
										<tr>
											<td>
												<!--- gingerbread --->
												<table id="fafsaCounts" border="0" cellpadding="0" cellspacing="2">
													<tr class="gingerbreadTopRow">
														<cfif gdsData.fafsaCountLeadingCols gt 0>
															<td colspan="#gdsData.fafsaCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td>#NumberFormat(gdsData.fafsaCompleted)#<br /><i class="icon-caret-down icon-3x blue"></i></td>
														<cfif gdsData.fafsaCountTrailingCols gt 0>
															<td colspan="#gdsData.fafsaCountTrailingCols#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfset gender = "female">
														<cfloop index="i" from="1" to="#gdsData.fafsaCompletedGingerbreadCount#">
															<!--- <td class="#gender#Blue"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/#gender#-blue.png" class="gingerbread" /></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.fafsaSubmittedGingerbreadCount#">
															<!--- <td class="#gender#Default"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/#gender#-default.png" class="gingerbread" /></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<td colspan="9"></td>
														<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(gdsData.fafsaSubmitted)#</td>
													</tr>
												</table>
											</td>
											<td align="right">
												<!--- teardrops --->
												<table id="fafsaPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="teardropHalfSmall">
														<td></td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="aquaTeardropNWSmall">
															<span class="upsize150">#gdsData.fafsaSubmittedPercent#%</span><br />Submitted
														</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="blueTeardropNESmall">
															<span class="upsize150">#gdsData.fafsaCompletedPercent#%</span><br />Complete
														</td>
													</tr>
													<tr class="teardropHalfSmall">
														<td></td>
													</tr>
												</table>
											</td>
										</tr>
									</table>
									<!--- <table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td>
												<!--- gingerbread --->
												<table id="fafsaCounts" border="0" cellpadding="0" cellspacing="2">
													<tr class="gingerbreadTopRow">
														<cfif gdsData.fafsaCountLeadingCols gt 0>
															<td colspan="#gdsData.fafsaCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td>#NumberFormat(gdsData.fafsaCompleted)#<br /><i class="icon-caret-down icon-3x blue"></i></td>
														<cfif gdsData.fafsaCountTrailingCols gt 0>
															<td colspan="#gdsData.fafsaCountTrailingCols#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfset gender = "female">
														<cfloop index="i" from="1" to="#gdsData.fafsaCompletedGingerbreadCount#">
															<td class="#gender#Blue"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.fafsaSubmittedGingerbreadCount#">
															<td class="#gender#Default"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<td colspan="9"></td>
														<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(gdsData.fafsaSubmitted)#</td>
													</tr>
												</table>
											</td>
											<td align="right">
												<!--- teardrops --->
												<table id="fafsaPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="teardropHalfSmall">
														<td></td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="aquaTeardropNWSmall"><span class="upsize150">#gdsData.fafsaSubmittedPercent#%</span><br />Submitted</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="blueTeardropNESmall"><span class="upsize150">#gdsData.fafsaCompletedPercent#%</span><br />Complete</td>
													</tr>
													<tr class="teardropHalfSmall">
														<td></td>
													</tr>
												</table>
											</td>
										</tr>
									</table> --->
								</td>
								<td>&nbsp;</td>
								<td>
									<table border="0" cellpadding="0" cellspacing="0" class="gingerbreadTable">
										<tr>
											<td>
												<!--- gingerbread --->
												<table id="calgrantCounts" border="0" cellpadding="0" cellspacing="2">
													<tr class="gingerbreadTopRow">
														<cfif gdsData.calgrantCountLeadingColsTop gt 0>
															<td colspan="#gdsData.calgrantCountLeadingColsTop#">&nbsp;</td>
														</cfif>
														<td>#NumberFormat(gdsData.calgrantCompleted)#<br /><i class="icon-caret-down icon-3x blue"></i></td>									
														<cfif gdsData.calgrantCountTrailingColsTop gt 0>
															<td colspan="#gdsData.calgrantCountTrailingColsTop#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfset gender = "female">
														<cfloop index="i" from="1" to="#gdsData.calgrantAwardedGingerbreadCount#">
															<!--- <td class="#gender#Green"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/#gender#-green.png" class="gingerbread" /></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.calgrantCompletedGingerbreadCount#">
															<!--- <td class="#gender#Blue"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/#gender#-blue.png" class="gingerbread" /></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.calgrantSubmittedGingerbreadCount#">
															<!--- <td class="#gender#Default"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/#gender#-default.png" class="gingerbread" /></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<cfif gdsData.calgrantCountLeadingColsBottom gt 0>
															<td colspan="#gdsData.calgrantCountLeadingColsBottom#">&nbsp;</td>
														</cfif>
														<td><i class="icon-caret-up icon-3x green"></i><br />#NumberFormat(gdsData.calgrantAwarded)#</td>	
														<cfif gdsData.calgrantCountTrailingColsBottom gt 0>
															<td colspan="#gdsData.calgrantCountTrailingColsBottom#">&nbsp;</td>
														</cfif>
														<cfif gdsData.calgrantAwarded neq gdsData.calgrantSubmitted>
															<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(gdsData.calgrantSubmitted)#</td>
														</cfif>
													</tr>
												</table>
											</td>
											<td align="right">
												<!--- teardrops --->
												<table id="calgrantPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="aquaTeardropNWSmall"><span class="upsize150">#gdsData.calgrantSubmittedPercent#%</span><br />Submitted</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="blueTeardropNESmall"><span class="upsize150">#gdsData.calgrantCompletedPercent#%</span><br />Complete</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="greenTeardropNESmall"><span class="upsize150">#gdsData.calgrantAwardedPercent#%</span><br />Offered</td>
													</tr>
												</table>
											</td>
										</tr>
									</table>
									<!--- <table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td>
												<!--- gingerbread --->
												<table id="calgrantCounts" border="0" cellpadding="0" cellspacing="2" class="gingerbreadTable">
													<tr class="gingerbreadTopRow">
														<cfif gdsData.calgrantCountLeadingColsTop gt 0>
															<td colspan="#gdsData.calgrantCountLeadingColsTop#">&nbsp;</td>
														</cfif>
														<td>#NumberFormat(gdsData.calgrantCompleted)#<br /><i class="icon-caret-down icon-3x blue"></i></td>									
														<cfif gdsData.calgrantCountTrailingColsTop gt 0>
															<td colspan="#gdsData.calgrantCountTrailingColsTop#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfset gender = "female">
														<cfloop index="i" from="1" to="#gdsData.calgrantAwardedGingerbreadCount#">
															<td class="#gender#Green"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.calgrantCompletedGingerbreadCount#">
															<td class="#gender#Blue"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.calgrantSubmittedGingerbreadCount#">
															<td class="#gender#Default"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<cfif gdsData.calgrantCountLeadingColsBottom gt 0>
															<td colspan="#gdsData.calgrantCountLeadingColsBottom#">&nbsp;</td>
														</cfif>
														<td><i class="icon-caret-up icon-3x green"></i><br />#NumberFormat(gdsData.calgrantAwarded)#</td>	
														<cfif gdsData.calgrantCountTrailingColsBottom gt 0>
															<td colspan="#gdsData.calgrantCountTrailingColsBottom#">&nbsp;</td>
														</cfif>
														<cfif gdsData.calgrantAwarded neq gdsData.calgrantSubmitted>
															<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(gdsData.calgrantSubmitted)#</td>
														</cfif>
													</tr>
												</table>
											</td>
											<td align="right">
												<!--- teardrops --->
												<table id="calgrantPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="aquaTeardropNWSmall"><span class="upsize150">#gdsData.calgrantSubmittedPercent#%</span><br />Submitted</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="blueTeardropNESmall"><span class="upsize150">#gdsData.calgrantCompletedPercent#%</span><br />Complete</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="greenTeardropNESmall"><span class="upsize150">#gdsData.calgrantAwardedPercent#%</span><br />Offered</td>
													</tr>
												</table>
											</td>
										</tr>
									</table> --->
								</td>
							</tr>
							<tr valign="top">
								<td>
									<!--- arrow --->
									<table border="0" cellpadding="0" cellspacing="0" width="100%">
										<tr class="dollarArrow">
											<td class="arrow">
												<img src="/assets/calgrants/ui/images/hdwd/pell-grant-arrow.png">
											</td>
											<td class="dollarAward" nowrap="nowrap" width="100%">$#NumberFormat(gdsData.fafsaDollarsAwarded)#</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td>
									<!--- arrow --->
									<table border="0" cellpadding="0" cellspacing="0" width="100%">
										<tr class="dollarArrow">
											<td class="arrow">
												<img src="/assets/calgrants/ui/images/hdwd/cal-grant-arrow.png">
											</td>
											<td class="dollarAward" nowrap="nowrap" width="100%">$#NumberFormat(gdsData.calgrantDollarsAwarded)#</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="statHeader">WORKSHOP RATING</td>
								<td>&nbsp;</td>
								<td class="statHeader">ATTENDANCE by GENDER</td>
							</tr>
							<tr valign="middle">
								<td>
									<!--- rating --->
									<table id="workshopRating" border="0" cellpadding="0" cellspacing="0">
										<tr class="ratingPercentRow">
											<td class="ratingPercent blue" width="25%">#Int(currentData[1].answers[1].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent green" width="25%">#Int(currentData[1].answers[2].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent blueDark" width="25%">#Int(currentData[1].answers[3].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent aqua" width="25%">#Int(currentData[1].answers[4].response_percent)#<span class="ratingPercentSymbol">%</span></td>
										</tr>
										<tr class="ratingPercentLabelRow">
											<td>Excellent</td>
											<td>Good</td>
											<td>Fair</td>
											<td>Poor</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td>
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td>
												<!--- gingerbread --->
												<table id="genderCounts" border="0" cellpadding="0" cellspacing="2" class="gingerbreadTable" width="100%">
													<tr class="gingerbreadTopRow">
														<cfif genderData.femaleCountLeadingCols gt 0>
															<td colspan="#genderData.femaleCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td class="greenMarkerDown">#NumberFormat(genderData.femaleCount)#<br /><i class="icon-caret-down icon-3x green"></i></td>
														<cfif genderData.femaleCountTrailingCols gt 1>
															<td colspan="#genderData.femaleCountTrailingCols#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfloop index="i" from="1" to="#genderData.femaleOnCount#">
															<td class="femaleGreen"></td>
														</cfloop>
														<cfloop index="i" from="1" to="#genderData.femaleOffCount#">
															<td class="femaleDefault"></td>
														</cfloop>
													</tr>
													<tr class="gingerbreadLowerRow">
														<cfloop index="i" from="1" to="#genderData.maleOnCount#">
															<td class="maleBlue"></td>
														</cfloop>
														<cfloop index="i" from="1" to="#genderData.maleOffCount#">
															<td class="maleDefault"></td>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<cfif genderData.maleCountLeadingCols gt 0>
															<td colspan="#genderData.maleCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td class="blueMarkerUp"><i class="icon-caret-up icon-3x blue"></i><br />#NumberFormat(genderData.maleCount)#</td>
														<cfif genderData.maleCountTrailingCols gt 0>
															<td colspan="#genderData.maleCountTrailingCols#">&nbsp;</td>
														</cfif>
														<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(genderData.maleFemaleCount)#</td>
													</tr>
												</table>
											</td>
											<td align="right">
												<!--- tearpanels --->
												<table id="genderPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="tearpanel">
														<td valign="top" class="femaleTearpanel">#Int(genderData.femalePercent)#%</td>
														<td valign="bottom" class="maleTearpanel">#Int(genderData.malePercent)#%</td>
													</tr>
												</table>

											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="statHeader">SENIOR ATTENDANCE</td>
								<td>&nbsp;</td>
								<td class="statHeader">ATTENDANCE by RACE/ETHNICITY</td>
							</tr>
							<tr valign="top">
								<td>
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td><div id="q7DonutChart" class="svgDonutChart"></div></td>
											<td valign="middle">
												<!--- legend --->
												<cfset answerData = currentData[7].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td align="left" width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td>
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td><div id="q12DonutChart" class="svgDonutChart"></div></td>
											<td>
												<!--- legend --->
												<cfset answerData = currentData[12].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td align="left" width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="statHeader">PARENT EDUCATION LEVEL</td>
								<td class="col21w">&nbsp;</td>
								<td class="statHeader">ATTENDED with PARENTS</td>
							</tr>
							<tr valign="top">
								<td>
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td><div id="q6DonutChart" class="svgDonutChart"></div></td>
											<td>
												<!--- legend --->
												<cfset answerData = currentData[6].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td>
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td><div id="q10DonutChart" class="svgDonutChart"></div></td>
											<td>
												<!--- legend --->
												<cfset answerData = currentData[10].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<!--- <tr>
					<td class="navCol" valign="bottom">
						<div class="mission">Cash for College is California's<br>public-private partnership FAFSA/CA Dream Act completion program administered by the California Student Aid Commission and its regional and local partners</div>
					</td>
				</tr> --->
			</table>
		</div>
	<cfelse>
		<!--- trend --->
		<div class="printPage">
			<table class="main" border="0" cellpadding="0" cellspacing="0">
				<tr valign="top">
					<td class="navCol" style="padding-top: 12px;">
						<table class="nav" border="0" cellpadding="0" cellspacing="0">
							<tr valign="top">
								<td class="navHeader" align="center">
									<table border="0" cellpadding="0" cellspacing="0" style="border-spacing: 0px;">
										<tr>
											<td class="logo" align="center"><img src="/assets/calgrants/ui/images/hdwd/cash-for-college-logo_hires.png" /></td>
										<tr>
											<td class="logoText" align="center">
												<img src="/assets/calgrants/ui/images/hdwd/how-did-we-do-cropped.png" />
												<div class="logoYearText">IN&nbsp;#ListLast(Program_Year, "-")#</div>
											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr valign="top">
								<td class="navBody">
									<cfif IsDefined("site")>
										<div class="sideLabel">Site Name</div>
										<div class="sideText">#site#</div>
									</cfif>
									<cfif IsDefined("siteType")>
										<div class="sideLabel">Site Type</div>
										<div class="sideText">#siteType#</div>
									</cfif>
									<cfif IsDefined("siteSince")>
										<div class="sideLabel">Site Since</div>
										<div class="sideText">#siteSince#</div>
									</cfif>
									<cfif IsDefined("city")>
										<div class="sideLabel">City</div>
										<div class="sideText">#city#</div>
									</cfif>
									<cfif IsDefined("county")>
										<div class="sideLabel">County</div>
										<div class="sideText">#county#</div>
									</cfif>
									<cfif IsDefined("region")>
										<div class="sideLabel">Region</div>
										<div class="sideText">#region#</div>
									</cfif>
									<cfif IsDefined("workshopDate")>
										<div class="sideLabel">Workshop Date</div>
										<div class="sideText">#DateFormat(workshopDate, "mmmm d, yyyy")#</div>
									</cfif>
									<cfif IsDefined("computerBasedWorkshop")>
										<div class="sideLabel">Computer Based Workshop</div>
										<div class="sideText">#YesNoFormat(computerBasedWorkshop)#</div>
									</cfif>
									<cfif IsDefined("organization")>
											<div class="sideLabel"><cfif Workshop_ID gt 0>Lead </cfif>Organization</div>
											<div class="sideText">#organization#</div>
									</cfif>
									<cfif IsDefined("organizationSince")>
										<div class="sideLabel">Organization Since</div>
										<div class="sideText">#organizationSince#</div>
									</cfif>
									<div class="sideLabel">Total Attendees</div>
									<div class="sideText">#NumberFormat(totalAttendees)#</div>
									<div class="sideLabel">Senior Attendees</div>
									<div class="sideText">#NumberFormat(seniorAttendees)# (#Int(seniorAttendeesPercent)#%)</div>
									<cfif IsDefined("followUpRequests") and IsDefined("followUpRequestsPct")>
										<div class="sideLabel">Follow-Up Requests</div>
										<div class="sideText">#followUpRequests# (#Int(followUpRequestsPct)#%)</div>
									</cfif>
									<cfif IsDefined("followedUp")>
										<div class="sideLabel">Used Follow-Up Platform?</div>
										<div class="sideText"><cfif followedUp gt 0>Yes (#followedUp#)<cfelse>No</cfif></div>
									</cfif>
									<!--- <cfif scholarshipCounts.RecordCount gt 0>
										<cfif Workshop_ID gt 0>
											<div class="sideLabel">Cash for College Scholarship Awarded?</div>
											<div class="sideText">Yes</div>
										<cfelse>
											<div class="sideLabel">Scholarships Awarded</div>
											<div class="sideText">Yes</div>
										</cfif>
									</cfif> --->
								</td>
							</tr>
						</table>
					</td>
					<td class="bodyCol" style="padding-top: 12px; padding-right: 10px; padding-left: 10px;">
						<table class="body" border="0" cellpadding="0" cellspacing="0" width="100%">
							<tr>
								<td class="statHeader">FAFSA/DREAM ACT APPLICATIONS</td>
								<td>&nbsp;</td>
								<td class="statHeader">CAL GRANT APPLICATIONS</td>
							</tr>
							<tr valign="top">
								<td>
									<table border="0" cellpadding="0" cellspacing="0" class="gingerbreadTable">
										<tr>
											<td>
												<!--- gingerbread --->
												<table id="fafsaCounts" border="0" cellpadding="0" cellspacing="2">
													<tr class="gingerbreadTopRow">
														<cfif gdsData.fafsaCountLeadingCols gt 0>
															<td colspan="#gdsData.fafsaCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td>#NumberFormat(gdsData.fafsaCompleted)#<br /><i class="icon-caret-down icon-3x blue"></i></td>
														<cfif gdsData.fafsaCountTrailingCols gt 0>
															<td colspan="#gdsData.fafsaCountTrailingCols#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfset gender = "female">
														<cfloop index="i" from="1" to="#gdsData.fafsaCompletedGingerbreadCount#">
															<!--- <td class="#gender#Blue"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/#gender#-blue.png" class="gingerbread" /></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.fafsaSubmittedGingerbreadCount#">
															<!--- <td class="#gender#Default"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/#gender#-default.png" class="gingerbread" /></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<td colspan="9"></td>
														<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(gdsData.fafsaSubmitted)#</td>
													</tr>
												</table>
											</td>
											<td align="right">
												<!--- teardrops --->
												<table id="fafsaPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="teardropHalfSmall">
														<td></td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="aquaTeardropNWSmall">
															<span class="upsize150">#gdsData.fafsaSubmittedPercent#%</span><br />Submitted
														</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="blueTeardropNESmall">
															<span class="upsize150">#gdsData.fafsaCompletedPercent#%</span><br />Complete
														</td>
													</tr>
													<tr class="teardropHalfSmall">
														<td></td>
													</tr>
												</table>
												<!--- <table id="fafsaPercentages" border="0" cellpadding="0" cellspacing="0">
													<tr class="teardropSmall">
														<td valign="middle" align="center">
															<img src="/assets/calgrants/ui/images/hdwd/print/teardrop-aqua.png" class="teardrop" />
															<!--- <span class="upsize150">#gdsData.fafsaSubmittedPercent#%</span><br />Submitted --->
														</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center">
															<img src="/assets/calgrants/ui/images/hdwd/print/teardrop-blue.png" class="teardrop" />
															<!--- <span class="upsize150">#gdsData.fafsaCompletedPercent#%</span><br />Complete --->
														</td>
													</tr>
												</table> --->
											</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td>
									<table border="0" cellpadding="0" cellspacing="0" class="gingerbreadTable">
										<tr>
											<td>
												<!--- gingerbread --->
												<table id="calgrantCounts" border="0" cellpadding="0" cellspacing="2">
													<tr class="gingerbreadTopRow">
														<cfif gdsData.calgrantCountLeadingColsTop gt 0>
															<td colspan="#gdsData.calgrantCountLeadingColsTop#">&nbsp;</td>
														</cfif>
														<td>#NumberFormat(gdsData.calgrantCompleted)#<br /><i class="icon-caret-down icon-3x blue"></i></td>									
														<cfif gdsData.calgrantCountTrailingColsTop gt 0>
															<td colspan="#gdsData.calgrantCountTrailingColsTop#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfset gender = "female">
														<cfloop index="i" from="1" to="#gdsData.calgrantAwardedGingerbreadCount#">
															<!--- <td class="#gender#Green"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/#gender#-green.png" class="gingerbread" /></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.calgrantCompletedGingerbreadCount#">
															<!--- <td class="#gender#Blue"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/#gender#-blue.png" class="gingerbread" /></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.calgrantSubmittedGingerbreadCount#">
															<!--- <td class="#gender#Default"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/#gender#-default.png" class="gingerbread" /></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<cfif gdsData.calgrantCountLeadingColsBottom gt 0>
															<td colspan="#gdsData.calgrantCountLeadingColsBottom#">&nbsp;</td>
														</cfif>
														<td><i class="icon-caret-up icon-3x green"></i><br />#NumberFormat(gdsData.calgrantAwarded)#</td>	
														<cfif gdsData.calgrantCountTrailingColsBottom gt 0>
															<td colspan="#gdsData.calgrantCountTrailingColsBottom#">&nbsp;</td>
														</cfif>
														<cfif gdsData.calgrantAwarded neq gdsData.calgrantSubmitted>
															<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(gdsData.calgrantSubmitted)#</td>
														</cfif>
													</tr>
												</table>
											</td>
											<td align="right">
												<!--- teardrops --->
												<table id="calgrantPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="aquaTeardropNWSmall"><span class="upsize150">#gdsData.calgrantSubmittedPercent#%</span><br />Submitted</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="blueTeardropNESmall"><span class="upsize150">#gdsData.calgrantCompletedPercent#%</span><br />Complete</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="greenTeardropNESmall"><span class="upsize150">#gdsData.calgrantAwardedPercent#%</span><br />Offered</td>
													</tr>
												</table>
												<!--- <table id="calgrantPercentages" border="0" cellpadding="0" cellspacing="0">
													<tr class="teardropSmall">
														<td valign="middle" align="center">
															<img src="/assets/calgrants/ui/images/hdwd/print/teardrop-aqua.png" class="teardrop" />
															<!--- <span class="upsize150">#gdsData.calgrantSubmittedPercent#%</span><br />Submitted --->
														</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center">
															<img src="/assets/calgrants/ui/images/hdwd/print/teardrop-blue.png" class="teardrop" />
															<!--- <span class="upsize150">#gdsData.calgrantCompletedPercent#%</span><br />Complete --->
														</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center">
															<img src="/assets/calgrants/ui/images/hdwd/print/teardrop-green.png" class="teardrop" />
															<!--- <span class="upsize150">#gdsData.calgrantAwardedPercent#%</span><br />Complete --->
														</td>
													</tr>
												</table> --->
											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr valign="top">
								<td>
									<!--- arrow --->
									<table border="0" cellpadding="0" cellspacing="0" width="100%">
										<tr class="dollarArrow">
											<td class="arrow">
												<img src="/assets/calgrants/ui/images/hdwd/pell-grant-arrow.png">
											</td>
											<td class="dollarAward" nowrap="nowrap" width="100%">$#NumberFormat(gdsData.fafsaDollarsAwarded)#</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td>
									<!--- arrow --->
									<table border="0" cellpadding="0" cellspacing="0" width="100%">
										<tr class="dollarArrow">
											<td class="arrow">
												<img src="/assets/calgrants/ui/images/hdwd/cal-grant-arrow.png">
											</td>
											<td class="dollarAward" nowrap="nowrap" width="100%">$#NumberFormat(gdsData.calgrantDollarsAwarded)#</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="statHeader">WORKSHOP RATING</td>
								<td>&nbsp;</td>
								<td class="trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="middle">
								<td>
									<!--- rating --->
									<table id="workshopRating" border="0" cellpadding="0" cellspacing="0">
										<tr class="ratingPercentRow">
											<td class="ratingPercent blue" width="25%">#Int(currentData[1].answers[1].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent green" width="25%">#Int(currentData[1].answers[2].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent blueDark" width="25%">#Int(currentData[1].answers[3].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent aqua" width="25%">#Int(currentData[1].answers[4].response_percent)#<span class="ratingPercentSymbol">%</span></td>
										</tr>
										<tr class="ratingPercentLabelRow">
											<td>Excellent</td>
											<td>Good</td>
											<td>Fair</td>
											<td>Poor</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td><div id="q1TrendLineChart" class="svgTrendLineChart"></div></td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="statHeader">ATTENDANCE by GENDER</td>
								<td>&nbsp;</td>
								<td class="trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="top">
								<td>
									<table border="0" cellpadding="0" cellspacing="0" class="gingerbreadTable">
										<tr>
											<td>
												<!--- gingerbread --->
												<table id="genderCounts" border="0" cellpadding="0" cellspacing="2">
													<tr class="gingerbreadTopRow">
														<cfif genderData.femaleCountLeadingCols gt 0>
															<td colspan="#genderData.femaleCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td class="greenMarkerDown">#NumberFormat(genderData.femaleCount)#<br /><i class="icon-caret-down icon-3x green"></i></td>
														<cfif genderData.femaleCountTrailingCols gt 1>
															<td colspan="#genderData.femaleCountTrailingCols#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfloop index="i" from="1" to="#genderData.femaleOnCount#">
															<!--- <td class="femaleGreen"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/female-green.png" class="gingerbread" /></td>
														</cfloop>
														<cfloop index="i" from="1" to="#genderData.femaleOffCount#">
															<!--- <td class="femaleDefault"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/female-default.png" class="gingerbread" /></td>
														</cfloop>
													</tr>
													<tr class="gingerbreadLowerRow">
														<cfloop index="i" from="1" to="#genderData.maleOnCount#">
															<!--- <td class="maleBlue"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/male-blue.png" class="gingerbread" /></td>
														</cfloop>
														<cfloop index="i" from="1" to="#genderData.maleOffCount#">
															<!--- <td class="maleDefault"></td> --->
															<td><img src="/assets/calgrants/ui/images/hdwd/print/male-default.png" class="gingerbread" /></td>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<cfif genderData.maleCountLeadingCols gt 0>
															<td colspan="#genderData.maleCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td class="blueMarkerUp"><i class="icon-caret-up icon-3x blue"></i><br />#NumberFormat(genderData.maleCount)#</td>
														<cfif genderData.maleCountTrailingCols gt 0>
															<td colspan="#genderData.maleCountTrailingCols#">&nbsp;</td>
														</cfif>
														<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(genderData.maleFemaleCount)#</td>
													</tr>
												</table>
											</td>
											<td align="right">
												<!--- tearpanels --->
												<table id="genderPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="tearpanel">
														<td valign="top" class="femaleTearpanel">#Int(genderData.femalePercent)#%</td>
														<td valign="bottom" class="maleTearpanel">#Int(genderData.malePercent)#%</td>
													</tr>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td><div id="q11TrendLineChart" class="svgTrendLineChart"></div></td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="statHeader">SENIOR ATTENDANCE</td>
								<td>&nbsp;</td>
								<td class="trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="top">
								<td>
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td><div id="q7DonutChart" class="svgDonutChart"></div></td>
											<td>
												<!--- legend --->
												<cfset answerData = currentData[7].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td align="left" width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td><div id="q7TrendAreaChart" class="svgTrendAreaChart"></div></td>
							</tr>
						</table>
					</td>
				</tr>
				<!--- <tr>
					<td class="navCol" valign="bottom">
						<table border="0" cellpadding="0" cellspacing="0">
							<tr>
								<td class="mission">
								Cash for College is California's<br>public-private partnership FAFSA/CA Dream Act completion program administered by the California Student Aid Commission and its regional and local partners
								</td>
							</tr>
						</table>
					</td>
				</tr> --->
			</table>
		</div>
		<div class="printPage">
			<table class="main" border="0" cellpadding="0" cellspacing="0">
				<tr valign="top">
					<td class="navCol">&nbsp;</td>
					<td class="bodyCol" style="padding-top: 12px; padding-right: 10px; padding-left: 10px;">
						<table border="0" cellpadding="0" cellspacing="0" width="100%">
							<tr>
								<td class="statHeader">ATTENDANCE by RACE/ETHNICITY</td>
								<td>&nbsp;</td>
								<td class="trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="top">
								<td>
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td><div id="q12DonutChart" class="svgDonutChart"></div></td>
											<td>
												<!--- legend --->
												<cfset answerData = currentData[12].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td align="left" width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td><div id="q12TrendLineChart" class="svgTrendLineChart"></div></td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="statHeader">PARENT EDUCATION LEVEL</td>
								<td class="col21w">&nbsp;</td>
								<td class="trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="top">
								<td>
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td><div id="q6DonutChart" class="svgDonutChart"></div></td>
											<td>
												<!--- legend --->
												<cfset answerData = currentData[6].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td><div id="q6TrendLineChart" class="svgTrendLineChart"></div></td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="statHeader">ATTENDED with PARENTS</td>
								<td class="col21w">&nbsp;</td>
								<td class="trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="top">
								<td>
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td><div id="q10DonutChart" class="svgDonutChart"></div></td>
											<td>
												<!--- legend --->
												<cfset answerData = currentData[10].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td>&nbsp;</td>
								<td><div id="q10TrendLineChart" class="svgTrendLineChart"></div></td>
							</tr>
						</table>
					</td>
				</tr>
			</table>
		</div>
	</cfif>
	<!--- Source of data --->
	<div class="printPage">
		<div class="main">
			<div class="sourceInfo">
				<h3 class="blueDark">SOURCE OF DATA</h3>
				<cfif Program_Year eq "2013-2014">
					<p>Each year California Cash for College collects participant exit surveys at the time of the workshop. How Did We Do summaries aggregate distinct participant exit surveys to create online reports. Participant FAFSA, California Dream Act Application and Cal Grant Application data was extracted from the California Student Aid Commission Grant Delivery System (GDS) in late July, 2014. 2014 How Did We Do report data may be lower due to matching at an earlier point in time (late July in 2014, vs. late October in 2013).</p>
				<cfelse>
					<p>Each year California Cash for College collects participant exit surveys at the time of the workshop. How Did We Do summaries aggregate distinct participant exit surveys to create online reports. Participant FAFSA, California Dream Act Application and Cal Grant Application data was extracted from the California Student Aid Commission Grant Delivery System (GDS) in late October #ListLast(Program_Year, "-")#.</p>
				</cfif>
				<hr />
				<table border="0" cellpadding="0" cellspacing="0">
					<tr valign="top">
						<td width="49%">
							<h3 class="blue">FAFSA/DREAM ACT APPLICATIONS</h3>
							
							<p>The Free Application for Federal Student Aid (FAFSA) and the CA Dream Act Application are gateway applications for grant financial aid in California. Application counts are grouped together.</p>
							
							<p><strong>SUBMITTED/COMPLETED FAFSAs & CA Dream Act Applications</strong></p>
							
							<p><strong>Submitted:</strong> Aggregate count of FAFSAs & CA Dream Act Applications submitted by workshop, organization, county, region, or state levels. Percentage is based on FAFSA/Dream Act Applications submitted from all Cash for College participants.</p>
							
							<p><strong>Completed:</strong> Aggregate count of FAFSAs & CA Dream Act Applications submitted AND that can be processed for financial aid. This means applications that have generated an Expected Family Contribution (EFC). Percentage is based on FAFSA/Dream Act Applications that have EFC, which means they can be processed for financial aid consideration.</p>
							
							<p><strong>Estimated Pell Grants:</strong> The federal government provides states Pell eligibility for each completed FAFSA. Using Pell eligibility for each qualifying applicant, and the most recently available average Pell Grant award of <cfif Program_Year lte "2012-2013">$3,685<cfelseif Program_Year eq "2013-2014">$3,678</cfif>, estimated Pell grant funding is displayed.</p>
						</td>
						<td width="2%"></td>
						<td width="49%">
							<h3 class="blue">CAL GRANT APPLICATIONS</h3>
							<p><strong>Submitted:</strong> Number of students who submitted a FAFSA or Dream Act Application and a Cal Grant GPA. Percentage is based on Cal Grant applications submitted from all workshop participants.</p>
							
							<p><strong>Completed:</strong> Students who submitted a complete FAFSA or Dream Act Application (one that has an EFC) and Cal Grant GPA by the March 2 deadline. Percentage is based on Cal Grant Applications that were complete and received by the deadline.</p>
							
							<p><strong>Offered:</strong> Number and percentage of applicants who were offered a Cal Grant Award.</p>
							
							<p><strong>Cal Grant Funding Offered:</strong> Using Commission Cal Grant award offer amounts, aggregated dollar amounts are displayed.</p>
						</td>
					</tr>
				</table>
				<hr />
				<table border="0" cellpadding="0" cellspacing="0">
					<tr valign="top">
						<td width="49%">
							<h3 class="blue">WORKSHOP RATING</h3>
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p>   
						</td>
						<td width="2%"></td>
						<td width="49%">
							<h3 class="blue">ATTENDANCE by GENDER</h3>
							<p>Percentages may not add up to 100 because students may have skipped the question, or answered declined to state.</p>
							
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p> 
						</td>
					</tr>
				</table>
				<hr />
				<table border="0" cellpadding="0" cellspacing="0">
					<tr valign="top">
						<td width="49%">
							<h3 class="blue">SENIOR ATTENDANCE</h3>
							<p>Percentages may not add up to 100 because students may have skipped the question.</p>
							
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p> 
						</td>
						<td width="2%"></td>
						<td width="49%">
							<h3 class="blue">ATTENDANCE by RACE/ETHNICITY</h3>
							<p>Percentages may exceed 100 percent as students may have marked more than one race/ethnicity.</p>
			
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p> 
						</td>
					</tr>
				</table>
				<hr />
				<table border="0" cellpadding="0" cellspacing="0">
					<tr valign="top">
						<td width="49%">
							<h3 class="blue">PARENT EDUCATION LEVEL</h3>
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p> 
						</td>
						<td width="2%"></td>
						<td width="49%">
							<h3 class="blue">ATTENDED with PARENTS</h3>
							<p>The definition of "Parents" includes guardians. The question is phrased: Did you attend with your parent/ guardian?</p>
							
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p> 
						</td>
					</tr>
				</table>
				<cfif Workshop_ID gt 0>
					<hr />
					<table border="0" cellpadding="0" cellspacing="0">
						<tr valign="top">
							<td>
								<h3 class="blue">OTHER CATEGORIES</h3>
								<p><strong>Computer based workshop:</strong> Workshop offered access to computers to offer students direct access to application completion.</p>
								
								<p><strong>Lead Organization:</strong> Cash for College involves multiple partners. The Lead Organization registers the workshop and takes a primary role in managing logistics for the workshop.</p>
								
								<p><strong>Organization Since:</strong> Cash for College workshops have been offered since 2003. Cash for College began matching participant data to the Commission's GDS in 2005. This data engine uses data beginning in 2009.</p>
								
								<p><strong>Follow Up Requests/Used Follow Up Platform:</strong> Each year, across all workshops statewide, about a third of students request some form of follow up assistance. Offering Follow Up assistance is part of the Cash for College model. In 2013 Cash for College launched a Student Follow Up tracking feature to assist students after the workshop to meet the March 2 deadline.</p>
								
								<p><strong>Scholarship Awarded:</strong> Since 2005, Cash for College has offered incentive scholarships for qualifying workshops to help students maximize their financial aid by applying for a Cal Grant.</p>
							</td>
						</tr>
					</table>
				</cfif>
			</div>
		</div>
	</div>
</cfoutput>
</body>
</html>
<cfsetting showdebugoutput="no">

<!-----------------------------------------------------------------
						Saved Code

<cfscript>
	if (desc === "These are unused filters for the HDWD report) {
		alert("foo");
	} else if (Organizer_ID gt 0) {
		// not implemented
		rollupLevel = "organizer";
		oID = Organizer_ID;
	} else if (Manager_ID gt 0) {
		// not implemented
		rollupLevel = "manager";
		oID = Manager_ID;
	} else if (Site_ID gt 0) {
		qSite = siteGateway.query(Site_ID = Site_ID);
		qOrganization = organizationGateway.query(Organization_ID = qSite.Organization_ID);
		qCounty = countyGateway.query(County_ID = qSite.County_ID);
		evaluations = evaluationGateway.report(programYears = Program_Year, siteIDs = Site_ID, excludeOtherResponses = true);
		gdsGateway = new assets.calgrants.com.gateway.GDSGateway();
		gds = gdsGateway.query(programYears = Program_Year, siteIDs = Site_ID);
		trendWorkshops = workshopGateway.query(Site_ID = Site_ID, Deleted = 0, Approved = 1);
		site = qSite.Site;
		organization = qOrganization.Organization;
		city = qSite.City;
		county = qCounty.County;
		region = qCounty.Region;
		siteType = qSite.Site_Type;
		siteSince = qSite.Initial_Program_Year;
		organizationSince = qOrganization.Initial_Program_Year;
		scholarshipCounts = storedProcedureGateway.getScholarshipCounts(Program_Year = Program_Year, Site_ID = Site_ID);
		rollupLevel = "site";
		oID = Site_ID;
	} else if (Zip_Code_ID gt 0) {
		// not implemented
		rollupLevel = "zipCode";
		oID = Zip_Code_ID;
	} else if (City_ID gt 0) {
		// not implemented
		rollupLevel = "city";
		oID = City_ID;
	} else if (County_ID gt 0) {
		qCounty = countyGateway.query(County_ID);
		evaluations = evaluationGateway.report(programYears = Program_Year, countyIDs = County_ID, excludeOtherResponses = true);
		gdsGateway = new assets.calgrants.com.gateway.GDSGateway();
		gds = gdsGateway.query(programYears = Program_Year, countyIDs = County_ID);
		trendWorkshops = workshopGateway.query(countyIDs = County_ID, Deleted = 0, Approved = 1);
		county = qCounty.County;
		region = qCounty.Region;
		scholarshipCounts = storedProcedureGateway.getScholarshipCounts(Program_Year = Program_Year, County_ID = County_ID);	
		rollupLevel = "county";
		oID = County_ID;
	} else if (School_District_ID gt 0) {
		// not implemented
		rollupLevel = "schoolDistrict";
		oID = School_District_ID;
	} else if (School_ID gt 0) {
		// not implemented
		rollupLevel = "school";
		oID = School_ID;
	} else if (State_Legislative_District_ID gt 0) {
		// not implemented
		rollupLevel = "stateLegislativeDistrict";
		oID = State_Legislative_District_ID;
	}
</cfscript>

------------------------------------------------------------------>